* merge worker-level data with instruments;
* merge establishment-level data with instruments;

* [] brackets indicate redacted internal census variable name or directory that can't be disclosed.; 


* define libraries;
libname hannah  '/projects/users/########';
libname ben '/projects/users/########';
libname hantmp  '/projects/users/########/tempfiles';

proc sql;
  create table hannah.ehf_icf_states_plants as
  select
    a.*, b.*
  from hannah.ehf_icf_states_plants as a
    left join hannah.all_piks_ivs_100p as b
    on a.pik = b.pik and a.year = b.[year]
  order by a.pik, a.year;
quit;


